USE master;
GO
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'HumanResources')
	DROP DATABASE HumanResources
GO
CREATE DATABASE HumanResources;
GO
USE HumanResources;
GO
CREATE SCHEMA hr;
GO
CREATE TABLE hr.Employees
(
	EmployeeID INT NOT NULL,
	FirstName NVARCHAR(50) NULL,
	LastName NVARCHAR(50) NULL,
	JobTitle NVARCHAR(50) NOT NULL,
	EmailAddress NVARCHAR(50) NULL,
	City NVARCHAR(50) NOT NULL,
	StateProvinceName NVARCHAR(50) NOT NULL,
	CountryRegionName NVARCHAR(50) NOT NULL
)
GO